Overview

Dataset Statistics

Number of Variables 58
Number of Observations 3912
Missing Cells 85956
Missing Cells (%) 37.9%
Duplicate Rows 0
Duplicate Rows (%) 0.0%
Total Size in Memory 1.7 MB
Average Record Size in Memory 464.0 B

Variable Types

Categorical 17
Numerical 40
Datetime 1

Variables

case_id

categorical

Distinct Count 3912
Unique (%) 100.0%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 9
Standard Deviation 0
Median 9
Minimum 9
Maximum 9

Sample

1st Row cs0000001
25% Row cs0000988
50% Row cs0001983
75% Row cs0003075
Last Row cs0004392

Letter

Count 7824
Lowercase Letter 7824
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 27384

likelihood_to_recommend

numerical

Distinct Count 2
Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Mean 0.3993
Minimum 0
Maximum 1
Zeros 2350
Zeros (%) 60.1%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 1
95-th Percentile 1
Maximum 1
Range 1
IQR 1

Descriptive Statistics

Standard Deviation 0.4898
Coefficient of Variation 1.2267
Kurtosis -1.8308
Mean 0.3993
Median Absolute Deviation 0
Skewness 0.4113
Sum 1562
Variance 0.2399

ticket_open_date

datetime

Distinct Count 693
Unique (%) 17.7%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB
Minimum 2017-11-03 00:00:00
Maximum 2020-01-26 00:00:00

support_plan

categorical

Distinct Count 4
Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 14
Standard Deviation 0
Median 14
Minimum 14
Maximum 14

Sample

1st Row support_tier_2
25% Row support_tier_1
50% Row support_tier_1
75% Row support_tier_2
Last Row support_tier_1

Letter

Count 43032
Lowercase Letter 43032
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 3912

account_type

categorical

Distinct Count 3
Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 14
Standard Deviation 0
Median 14
Minimum 14
Maximum 14

Sample

1st Row account_type_1
25% Row account_type_2
50% Row account_type_2
75% Row account_type_1
Last Row account_type_2

Letter

Count 43032
Lowercase Letter 43032
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 3912

sr_severity

numerical

Distinct Count 4
Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Mean 3.7308
Minimum 1
Maximum 4
Zeros 0
Zeros (%) 0.0%
Memory Size 30.7 KB

Quantile Statistics

Minimum 1
5-th Percentile 2
Q1 4
Median 4
Q3 4
95-th Percentile 4
Maximum 4
Range 3
IQR 0

Descriptive Statistics

Standard Deviation 0.6802
Coefficient of Variation 0.1823
Kurtosis 5.6713
Mean 3.7308
Median Absolute Deviation 0
Skewness -2.5655
Sum 14595
Variance 0.4627

technology_level_1

categorical

Distinct Count 2
Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 12.3264
Standard Deviation 3.4961
Median 9
Minimum 9
Maximum 16

Sample

1st Row technical
25% Row technical
50% Row customer support
75% Row customer support
Last Row technical

Letter

Count 46362
Lowercase Letter 46362
Space Separator 1859
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 0

technology_level_2

categorical

Distinct Count 10
Unique (%) 0.3%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 18.0038
Standard Deviation 0.06181
Median 18
Minimum 18
Maximum 19

Sample

1st Row assignment_group_2
25% Row assignment_group_2
50% Row assignment_group_1
75% Row assignment_group_1
Last Row assignment_group_3

Letter

Count 58680
Lowercase Letter 58680
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 3927

technology_level_3

categorical

Distinct Count 142
Unique (%) 3.6%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 20.2561
Standard Deviation 0.4671
Median 20
Minimum 20
Maximum 22

Sample

1st Row technology_level_3_4
25% Row technology_level_3_4
50% Row technology_level_3_1
75% Row technology_level_3_1
Last Row technology_level_3_2

Letter

Count 58680
Lowercase Letter 58680
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 8826

assignment_count

numerical

Distinct Count 11
Unique (%) 0.3%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Mean 0.4379
Minimum 0
Maximum 12
Zeros 2774
Zeros (%) 70.9%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 0
Q3 1
95-th Percentile 2
Maximum 12
Range 12
IQR 1

Descriptive Statistics

Standard Deviation 0.905
Coefficient of Variation 2.0667
Kurtosis 22.4751
Mean 0.4379
Median Absolute Deviation 0
Skewness 3.7359
Sum 1713
Variance 0.8189

meaningful_comm_count

numerical

Distinct Count 48
Unique (%) 1.2%
Missing 58
Missing (%) 1.5%
Infinite 0
Infinite (%) 0.0%
Mean 4.0908
Minimum 0
Maximum 174
Zeros 4
Zeros (%) 0.1%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 1
Q1 1
Median 3
Q3 5
95-th Percentile 12
Maximum 174
Range 174
IQR 4

Descriptive Statistics

Standard Deviation 5.8517
Coefficient of Variation 1.4305
Kurtosis 223.6841
Mean 4.0908
Median Absolute Deviation 2.9652
Skewness 10.612
Sum 15766
Variance 34.2425

first_meaningful_comm_duration_mins

numerical

Distinct Count 1668
Unique (%) 42.6%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Mean 5932.2408
Minimum 0
Maximum 364627
Zeros 629
Zeros (%) 16.1%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 11
Median 115
Q3 1349.9248
95-th Percentile 22358.0473
Maximum 364627
Range 364627
IQR 1338.9248

Descriptive Statistics

Standard Deviation 24240.3918
Coefficient of Variation 4.0862
Kurtosis 64.3609
Mean 5932.2408
Median Absolute Deviation 167.5338
Skewness 7.3134
Sum 2.3207e+07
Variance 5.876e+08

all_avg_meaningful_comm_duration_mins

numerical

Distinct Count 2324
Unique (%) 59.4%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Mean 5307.3592
Minimum 0
Maximum 277959
Zeros 473
Zeros (%) 12.1%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 71
Median 908
Q3 3369.5809
95-th Percentile 18979.5929
Maximum 277959
Range 277959
IQR 3298.5809

Descriptive Statistics

Standard Deviation 17339.7495
Coefficient of Variation 3.2671
Kurtosis 79.0596
Mean 5307.3592
Median Absolute Deviation 1288.3794
Skewness 7.7791
Sum 2.0762e+07
Variance 3.0067e+08

case_origination_source

categorical

Distinct Count 11
Unique (%) 0.3%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 25.001
Standard Deviation 0.03196
Median 25
Minimum 25
Maximum 26

Sample

1st Row case_origination_source_1
25% Row case_origination_source_1
50% Row case_origination_source_4
75% Row case_origination_source_5
Last Row case_origination_source_2

Letter

Count 82152
Lowercase Letter 82152
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 3916

case_origination_user_type

categorical

Distinct Count 2
Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 28
Standard Deviation 0
Median 28
Minimum 28
Maximum 28

Sample

1st Row case_origination_user_t...
25% Row case_origination_user_t...
50% Row case_origination_user_t...
75% Row case_origination_user_t...
Last Row case_origination_user_t...

Letter

Count 89976
Lowercase Letter 89976
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 3912

dayofweek

categorical

Distinct Count 2
Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 7
Standard Deviation 0
Median 7
Minimum 7
Maximum 7

Sample

1st Row weekday
25% Row weekday
50% Row weekday
75% Row weekday
Last Row weekday

Letter

Count 27384
Lowercase Letter 27384
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 0

timewindow

categorical

Distinct Count 2
Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 11.5327
Standard Deviation 1.9449
Median 10
Minimum 10
Maximum 14

Sample

1st Row non_prime_time
25% Row prime_time
50% Row prime_time
75% Row prime_time
Last Row non_prime_time

Letter

Count 39705
Lowercase Letter 39705
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 0

severity_change

categorical

Distinct Count 2
Unique (%) 0.1%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 2.0463
Standard Deviation 0.2101
Median 2
Minimum 2
Maximum 3

Sample

1st Row no
25% Row no
50% Row no
75% Row no
Last Row no

Letter

Count 8005
Lowercase Letter 8005
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 0

age_of_account_days

numerical

Distinct Count 930
Unique (%) 66.5%
Missing 2513
Missing (%) 64.2%
Infinite 0
Infinite (%) 0.0%
Mean 6278.3674
Minimum 291
Maximum 43836
Zeros 0
Zeros (%) 0.0%
Memory Size 30.7 KB

Quantile Statistics

Minimum 291
5-th Percentile 545.6958
Q1 935.7988
Median 1719.7582
Q3 3547
95-th Percentile 42975
Maximum 43836
Range 43545
IQR 2611.2012

Descriptive Statistics

Standard Deviation 12567.9146
Coefficient of Variation 2.0018
Kurtosis 4.4009
Mean 6278.3674
Median Absolute Deviation 1347.6834
Skewness 2.5062
Sum 8.7834e+06
Variance 1.5795e+08

life_time_spend_usd

numerical

Distinct Count 1364
Unique (%) 56.0%
Missing 1477
Missing (%) 37.8%
Infinite 0
Infinite (%) 0.0%
Mean 532526.6587
Minimum -855321
Maximum 1.0149e+08
Zeros 770
Zeros (%) 19.7%
Memory Size 30.7 KB

Quantile Statistics

Minimum -855321
5-th Percentile 0
Q1 0
Median 2291.682
Q3 40776.1461
95-th Percentile 1.1784e+06
Maximum 1.0149e+08
Range 1.0234e+08
IQR 40776.1461

Descriptive Statistics

Standard Deviation 3.5275e+06
Coefficient of Variation 6.6242
Kurtosis 375.0449
Mean 532526.6587
Median Absolute Deviation 3650.1612
Skewness 16.5091
Sum 1.2967e+09
Variance 1.2444e+13

monthly_recurring_revenue_usd

numerical

Distinct Count 686
Unique (%) 55.7%
Missing 2681
Missing (%) 68.5%
Infinite 0
Infinite (%) 0.0%
Mean 21613.0041
Minimum 0
Maximum 1.6661e+06
Zeros 333
Zeros (%) 8.5%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0
Q1 0
Median 448.5273
Q3 4357.4545
95-th Percentile 108001.8727
Maximum 1.6661e+06
Range 1.6661e+06
IQR 4357.4545

Descriptive Statistics

Standard Deviation 99391.0477
Coefficient of Variation 4.5987
Kurtosis 138.4567
Mean 21613.0041
Median Absolute Deviation 622.692
Skewness 10.1873
Sum 2.6606e+07
Variance 9.8786e+09

ticket_duration_days

numerical

Distinct Count 611
Unique (%) 15.6%
Missing 0
Missing (%) 0.0%
Infinite 0
Infinite (%) 0.0%
Mean 194.1472
Minimum 0
Maximum 733
Zeros 98
Zeros (%) 2.5%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 4
Q1 40
Median 170
Q3 312
95-th Percentile 490.6305
Maximum 733
Range 733
IQR 272

Descriptive Statistics

Standard Deviation 167.5738
Coefficient of Variation 0.8631
Kurtosis -0.04984
Mean 194.1472
Median Absolute Deviation 198.6684
Skewness 0.7682
Sum 759504
Variance 28080.9637

tribe_level_1

categorical

Distinct Count 45
Unique (%) 1.8%
Missing 1415
Missing (%) 36.2%
Memory Size 30.7 KB

Length

Mean 15.1614
Standard Deviation 0.368
Median 15
Minimum 15
Maximum 16

Sample

1st Row tribe_level_1_3
25% Row tribe_level_1_3
50% Row tribe_level_1_1
75% Row tribe_level_1_1
Last Row nan

Letter

Count 24970
Lowercase Letter 24970
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 5397

tribe_level_2

categorical

Distinct Count 12
Unique (%) 0.5%
Missing 1415
Missing (%) 36.2%
Memory Size 30.7 KB

Length

Mean 15.0056
Standard Deviation 0.07468
Median 15
Minimum 15
Maximum 16

Sample

1st Row tribe_level_2_2
25% Row tribe_level_2_2
50% Row tribe_level_2_1
75% Row tribe_level_2_1
Last Row nan

Letter

Count 24970
Lowercase Letter 24970
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 5008

catalog_name

categorical

Distinct Count 113
Unique (%) 4.5%
Missing 1415
Missing (%) 36.2%
Memory Size 30.7 KB

Length

Mean 15.2555
Standard Deviation 0.4489
Median 15
Minimum 15
Maximum 17

Sample

1st Row catalog_level_3
25% Row catalog_level_3
50% Row catalog_level_1
75% Row catalog_level_1
Last Row nan

Letter

Count 29964
Lowercase Letter 29964
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 3135

sentiment_overall

numerical

Distinct Count 1284
Unique (%) 86.7%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.201
Minimum -0.9944
Maximum 0.9999
Zeros 189
Zeros (%) 4.8%
Memory Size 30.7 KB

Quantile Statistics

Minimum -0.9944
5-th Percentile -0.7867
Q1 -0.3566
Median 0.3518
Q3 0.7306
95-th Percentile 0.9779
Maximum 0.9999
Range 1.9943
IQR 1.0872

Descriptive Statistics

Standard Deviation 0.6033
Coefficient of Variation 3.0017
Kurtosis -1.2665
Mean 0.201
Median Absolute Deviation 0.7258
Skewness -0.3244
Sum 297.6515
Variance 0.364

anger_overall

numerical

Distinct Count 1405
Unique (%) 94.9%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.07826
Minimum 0
Maximum 0.6952
Zeros 14
Zeros (%) 0.4%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.01076
Q1 0.0349
Median 0.06197
Q3 0.09161
95-th Percentile 0.1729
Maximum 0.6952
Range 0.6952
IQR 0.05671

Descriptive Statistics

Standard Deviation 0.08253
Coefficient of Variation 1.0546
Kurtosis 17.7955
Mean 0.07826
Median Absolute Deviation 0.04356
Skewness 3.6849
Sum 115.8976
Variance 0.006811

disgust_overall

numerical

Distinct Count 1392
Unique (%) 94.0%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.04389
Minimum 0
Maximum 0.6848
Zeros 17
Zeros (%) 0.4%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.002491
Q1 0.01503
Median 0.03142
Q3 0.04724
95-th Percentile 0.08604
Maximum 0.6848
Range 0.6848
IQR 0.03221

Descriptive Statistics

Standard Deviation 0.07359
Coefficient of Variation 1.6767
Kurtosis 40.538
Mean 0.04389
Median Absolute Deviation 0.02493
Skewness 5.9386
Sum 64.9977
Variance 0.005415

fear_overall

numerical

Distinct Count 1401
Unique (%) 94.6%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.0659
Minimum 0
Maximum 0.7256
Zeros 18
Zeros (%) 0.5%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.00425
Q1 0.0219
Median 0.05023
Q3 0.07876
95-th Percentile 0.1374
Maximum 0.7256
Range 0.7256
IQR 0.05685

Descriptive Statistics

Standard Deviation 0.08714
Coefficient of Variation 1.3223
Kurtosis 26.4772
Mean 0.0659
Median Absolute Deviation 0.04324
Skewness 4.6622
Sum 97.5978
Variance 0.007593

joy_overall

numerical

Distinct Count 1408
Unique (%) 95.1%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.2954
Minimum 0
Maximum 0.9132
Zeros 9
Zeros (%) 0.2%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.0211
Q1 0.07848
Median 0.1667
Q3 0.5419
95-th Percentile 0.6627
Maximum 0.9132
Range 0.9132
IQR 0.4634

Descriptive Statistics

Standard Deviation 0.2461
Coefficient of Variation 0.833
Kurtosis -1.354
Mean 0.2954
Median Absolute Deviation 0.2144
Skewness 0.4372
Sum 437.5603
Variance 0.06058

sadness_overall

numerical

Distinct Count 1410
Unique (%) 95.2%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.2796
Minimum 0
Maximum 0.8628
Zeros 12
Zeros (%) 0.3%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.01372
Q1 0.07859
Median 0.1852
Q3 0.5102
95-th Percentile 0.6102
Maximum 0.8628
Range 0.8628
IQR 0.4316

Descriptive Statistics

Standard Deviation 0.2249
Coefficient of Variation 0.8046
Kurtosis -1.3983
Mean 0.2796
Median Absolute Deviation 0.2398
Skewness 0.3587
Sum 414.0298
Variance 0.0506

sentiment_last3_conversation

numerical

Distinct Count 1264
Unique (%) 85.4%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.1637
Minimum -0.9944
Maximum 0.9999
Zeros 207
Zeros (%) 5.3%
Memory Size 30.7 KB

Quantile Statistics

Minimum -0.9944
5-th Percentile -0.8367
Q1 -0.4192
Median 0.2957
Q3 0.7307
95-th Percentile 0.9801
Maximum 0.9999
Range 1.9943
IQR 1.1498

Descriptive Statistics

Standard Deviation 0.6296
Coefficient of Variation 3.8471
Kurtosis -1.3508
Mean 0.1637
Median Absolute Deviation 0.8362
Skewness -0.258
Sum 242.3916
Variance 0.3964

anger_sentiment_last3

numerical

Distinct Count 1402
Unique (%) 94.7%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.07691
Minimum 0
Maximum 0.6952
Zeros 16
Zeros (%) 0.4%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.009192
Q1 0.03107
Median 0.05955
Q3 0.09153
95-th Percentile 0.1812
Maximum 0.6952
Range 0.6952
IQR 0.06046

Descriptive Statistics

Standard Deviation 0.08306
Coefficient of Variation 1.08
Kurtosis 17.6853
Mean 0.07691
Median Absolute Deviation 0.0461
Skewness 3.6321
Sum 113.9083
Variance 0.0069

disgust_sentiment_last3

numerical

Distinct Count 1392
Unique (%) 94.0%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.04174
Minimum 0
Maximum 0.6848
Zeros 19
Zeros (%) 0.5%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.001988
Q1 0.01297
Median 0.02794
Q3 0.04616
95-th Percentile 0.08917
Maximum 0.6848
Range 0.6848
IQR 0.03319

Descriptive Statistics

Standard Deviation 0.06947
Coefficient of Variation 1.6643
Kurtosis 42.4042
Mean 0.04174
Median Absolute Deviation 0.02532
Skewness 5.9578
Sum 61.8145
Variance 0.004825

fear_sentiment_last3

numerical

Distinct Count 1400
Unique (%) 94.5%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.06327
Minimum 0
Maximum 0.7256
Zeros 19
Zeros (%) 0.5%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.003941
Q1 0.01962
Median 0.04717
Q3 0.0772
95-th Percentile 0.1381
Maximum 0.7256
Range 0.7256
IQR 0.05758

Descriptive Statistics

Standard Deviation 0.08268
Coefficient of Variation 1.3069
Kurtosis 28.4528
Mean 0.06327
Median Absolute Deviation 0.04427
Skewness 4.7163
Sum 93.6987
Variance 0.006837

joy_sentiment_last3

numerical

Distinct Count 1410
Unique (%) 95.2%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.2577
Minimum 0
Maximum 0.9132
Zeros 9
Zeros (%) 0.2%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.01914
Q1 0.06496
Median 0.1318
Q3 0.4795
95-th Percentile 0.6604
Maximum 0.9132
Range 0.9132
IQR 0.4145

Descriptive Statistics

Standard Deviation 0.2394
Coefficient of Variation 0.9291
Kurtosis -0.9245
Mean 0.2577
Median Absolute Deviation 0.1547
Skewness 0.748
Sum 381.6943
Variance 0.05734

sadness_sentiment_last3

numerical

Distinct Count 1408
Unique (%) 95.1%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.2637
Minimum 0
Maximum 0.8628
Zeros 12
Zeros (%) 0.3%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.01332
Q1 0.07065
Median 0.1731
Q3 0.4812
95-th Percentile 0.6181
Maximum 0.8628
Range 0.8628
IQR 0.4105

Descriptive Statistics

Standard Deviation 0.2216
Coefficient of Variation 0.8406
Kurtosis -1.1623
Mean 0.2637
Median Absolute Deviation 0.2104
Skewness 0.5315
Sum 390.4866
Variance 0.04912

sentiment_last_conversation

numerical

Distinct Count 1070
Unique (%) 72.2%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.09002
Minimum -0.9924
Maximum 0.9999
Zeros 398
Zeros (%) 10.2%
Memory Size 30.7 KB

Quantile Statistics

Minimum -0.9924
5-th Percentile -0.8898
Q1 -0.4352
Median 0
Q3 0.6676
95-th Percentile 0.9813
Maximum 0.9999
Range 1.9923
IQR 1.1028

Descriptive Statistics

Standard Deviation 0.6318
Coefficient of Variation 7.0183
Kurtosis -1.2488
Mean 0.09002
Median Absolute Deviation 0.8857
Skewness -0.08562
Sum 133.3124
Variance 0.3991

anger_last_conversation

numerical

Distinct Count 1370
Unique (%) 92.5%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.07382
Minimum 0
Maximum 0.6513
Zeros 35
Zeros (%) 0.9%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.004725
Q1 0.02467
Median 0.05332
Q3 0.09475
95-th Percentile 0.1888
Maximum 0.6513
Range 0.6513
IQR 0.07008

Descriptive Statistics

Standard Deviation 0.07482
Coefficient of Variation 1.0136
Kurtosis 8.7305
Mean 0.07382
Median Absolute Deviation 0.05219
Skewness 2.4653
Sum 109.3248
Variance 0.005599

disgust_last_conversation

numerical

Distinct Count 1355
Unique (%) 91.5%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.04009
Minimum 0
Maximum 0.6856
Zeros 38
Zeros (%) 1.0%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.00084958
Q1 0.009675
Median 0.02275
Q3 0.04741
95-th Percentile 0.1095
Maximum 0.6856
Range 0.6856
IQR 0.03774

Descriptive Statistics

Standard Deviation 0.06027
Coefficient of Variation 1.5036
Kurtosis 37.5943
Mean 0.04009
Median Absolute Deviation 0.02521
Skewness 5.0793
Sum 59.3663
Variance 0.003633

fear_last_conversation

numerical

Distinct Count 1370
Unique (%) 92.5%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.06106
Minimum 0
Maximum 0.8059
Zeros 34
Zeros (%) 0.9%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.002471
Q1 0.01378
Median 0.03945
Q3 0.07895
95-th Percentile 0.1636
Maximum 0.8059
Range 0.8059
IQR 0.06517

Descriptive Statistics

Standard Deviation 0.07824
Coefficient of Variation 1.2815
Kurtosis 27.1936
Mean 0.06106
Median Absolute Deviation 0.04317
Skewness 4.2186
Sum 90.424
Variance 0.006122

joy_last_conversation

numerical

Distinct Count 1373
Unique (%) 92.7%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.189
Minimum 0
Maximum 0.9284
Zeros 29
Zeros (%) 0.7%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.01317
Q1 0.04249
Median 0.1005
Q3 0.2363
95-th Percentile 0.6419
Maximum 0.9284
Range 0.9284
IQR 0.1938

Descriptive Statistics

Standard Deviation 0.2111
Coefficient of Variation 1.1173
Kurtosis 1.228
Mean 0.189
Median Absolute Deviation 0.108
Skewness 1.4824
Sum 279.877
Variance 0.04458

sadness_last_conversation

numerical

Distinct Count 1373
Unique (%) 92.7%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.2207
Minimum 0
Maximum 0.8666
Zeros 33
Zeros (%) 0.8%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.007243
Q1 0.04518
Median 0.1453
Q3 0.3413
95-th Percentile 0.6221
Maximum 0.8666
Range 0.8666
IQR 0.2961

Descriptive Statistics

Standard Deviation 0.2115
Coefficient of Variation 0.9585
Kurtosis -0.1422
Mean 0.2207
Median Absolute Deviation 0.1702
Skewness 0.9771
Sum 326.8112
Variance 0.04473

sentiment_short_description

numerical

Distinct Count 503
Unique (%) 34.0%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean -0.2285
Minimum -0.9874
Maximum 0.9922
Zeros 971
Zeros (%) 24.8%
Memory Size 30.7 KB

Quantile Statistics

Minimum -0.9874
5-th Percentile -0.9074
Q1 -0.6599
Median 0
Q3 0
95-th Percentile 0
Maximum 0.9922
Range 1.9796
IQR 0.6599

Descriptive Statistics

Standard Deviation 0.4037
Coefficient of Variation -1.7667
Kurtosis -0.5177
Mean -0.2285
Median Absolute Deviation 0
Skewness -0.4674
Sum -338.3841
Variance 0.1629

anger_short_description

numerical

Distinct Count 1330
Unique (%) 89.8%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.1051
Minimum 0
Maximum 0.931
Zeros 23
Zeros (%) 0.6%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.01514
Q1 0.04958
Median 0.08704
Q3 0.1325
95-th Percentile 0.2539
Maximum 0.931
Range 0.931
IQR 0.08287

Descriptive Statistics

Standard Deviation 0.08762
Coefficient of Variation 0.8336
Kurtosis 10.9977
Mean 0.1051
Median Absolute Deviation 0.06419
Skewness 2.3991
Sum 155.6677
Variance 0.007678

disgust_short_description

numerical

Distinct Count 1325
Unique (%) 89.5%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.05773
Minimum 0
Maximum 0.931
Zeros 23
Zeros (%) 0.6%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.006153
Q1 0.01892
Median 0.03761
Q3 0.07295
95-th Percentile 0.1503
Maximum 0.931
Range 0.931
IQR 0.05403

Descriptive Statistics

Standard Deviation 0.07353
Coefficient of Variation 1.2737
Kurtosis 43.4402
Mean 0.05773
Median Absolute Deviation 0.03525
Skewness 5.3158
Sum 85.4952
Variance 0.005406

fear_short_description

numerical

Distinct Count 1332
Unique (%) 89.9%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.0738
Minimum 0
Maximum 0.931
Zeros 23
Zeros (%) 0.6%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.008949
Q1 0.03174
Median 0.05744
Q3 0.09409
95-th Percentile 0.1798
Maximum 0.931
Range 0.931
IQR 0.06235

Descriptive Statistics

Standard Deviation 0.06781
Coefficient of Variation 0.9188
Kurtosis 30.1798
Mean 0.0738
Median Absolute Deviation 0.04813
Skewness 3.8049
Sum 109.3033
Variance 0.004598

joy_short_description

numerical

Distinct Count 1345
Unique (%) 90.8%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.1152
Minimum 0
Maximum 0.7617
Zeros 24
Zeros (%) 0.6%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.01004
Q1 0.03228
Median 0.06463
Q3 0.1574
95-th Percentile 0.3654
Maximum 0.7617
Range 0.7617
IQR 0.1251

Descriptive Statistics

Standard Deviation 0.1304
Coefficient of Variation 1.1328
Kurtosis 5.2975
Mean 0.1152
Median Absolute Deviation 0.06676
Skewness 2.1895
Sum 170.5379
Variance 0.01701

sadness_short_description

numerical

Distinct Count 1336
Unique (%) 90.2%
Missing 2431
Missing (%) 62.1%
Infinite 0
Infinite (%) 0.0%
Mean 0.2782
Minimum 0
Maximum 0.9167
Zeros 23
Zeros (%) 0.6%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.03938
Q1 0.1142
Median 0.1977
Q3 0.3968
95-th Percentile 0.7297
Maximum 0.9167
Range 0.9167
IQR 0.2826

Descriptive Statistics

Standard Deviation 0.2228
Coefficient of Variation 0.8007
Kurtosis -0.02811
Mean 0.2782
Median Absolute Deviation 0.1704
Skewness 1
Sum 412.0286
Variance 0.04962

sentiment_description

numerical

Distinct Count 917
Unique (%) 80.5%
Missing 2773
Missing (%) 70.9%
Infinite 0
Infinite (%) 0.0%
Mean 0.1406
Minimum -0.9983
Maximum 400
Zeros 216
Zeros (%) 5.5%
Memory Size 30.7 KB

Quantile Statistics

Minimum -0.9983
5-th Percentile -0.9146
Q1 -0.715
Median -0.3439
Q3 0.3001
95-th Percentile 0.7888
Maximum 400
Range 400.9983
IQR 1.0151

Descriptive Statistics

Standard Deviation 11.8721
Coefficient of Variation 84.44
Kurtosis 1128.7788
Mean 0.1406
Median Absolute Deviation 0.5575
Skewness 33.5883
Sum 160.141
Variance 140.9462

anger_description

numerical

Distinct Count 1129
Unique (%) 99.1%
Missing 2773
Missing (%) 70.9%
Infinite 0
Infinite (%) 0.0%
Mean 0.4366
Minimum 0
Maximum 400
Zeros 5
Zeros (%) 0.1%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.009582
Q1 0.03723
Median 0.06753
Q3 0.1066
95-th Percentile 0.2147
Maximum 400
Range 400
IQR 0.06935

Descriptive Statistics

Standard Deviation 11.8499
Coefficient of Variation 27.1393
Kurtosis 1133.8933
Mean 0.4366
Median Absolute Deviation 0.04905
Skewness 33.7022
Sum 497.3254
Variance 140.4207

disgust_description

numerical

Distinct Count 1122
Unique (%) 98.5%
Missing 2773
Missing (%) 70.9%
Infinite 0
Infinite (%) 0.0%
Mean 0.3926
Minimum 0
Maximum 400
Zeros 7
Zeros (%) 0.2%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.001142
Q1 0.01036
Median 0.02692
Q3 0.05227
95-th Percentile 0.1133
Maximum 400
Range 400
IQR 0.04191

Descriptive Statistics

Standard Deviation 11.8511
Coefficient of Variation 30.1847
Kurtosis 1133.9455
Mean 0.3926
Median Absolute Deviation 0.02744
Skewness 33.7034
Sum 447.1935
Variance 140.4484

fear_description

numerical

Distinct Count 1131
Unique (%) 99.3%
Missing 2773
Missing (%) 70.9%
Infinite 0
Infinite (%) 0.0%
Mean 0.4153
Minimum 0
Maximum 400
Zeros 3
Zeros (%) 0.1%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.005312
Q1 0.02543
Median 0.05448
Q3 0.08518
95-th Percentile 0.1528
Maximum 400
Range 400
IQR 0.05975

Descriptive Statistics

Standard Deviation 11.8504
Coefficient of Variation 28.5357
Kurtosis 1133.9436
Mean 0.4153
Median Absolute Deviation 0.04284
Skewness 33.7033
Sum 473.0084
Variance 140.4326

joy_description

numerical

Distinct Count 1133
Unique (%) 99.5%
Missing 2773
Missing (%) 70.9%
Infinite 0
Infinite (%) 0.0%
Mean 0.4975
Minimum 0
Maximum 400
Zeros 1
Zeros (%) 0.0%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.01241
Q1 0.02858
Median 0.07351
Q3 0.1614
95-th Percentile 0.5795
Maximum 400
Range 400
IQR 0.1328

Descriptive Statistics

Standard Deviation 11.8492
Coefficient of Variation 23.8174
Kurtosis 1133.4695
Mean 0.4975
Median Absolute Deviation 0.07191
Skewness 33.6928
Sum 566.6556
Variance 140.4041

sadness_description

numerical

Distinct Count 1136
Unique (%) 99.7%
Missing 2773
Missing (%) 70.9%
Infinite 0
Infinite (%) 0.0%
Mean 0.6511
Minimum 0
Maximum 400
Zeros 1
Zeros (%) 0.0%
Memory Size 30.7 KB

Quantile Statistics

Minimum 0
5-th Percentile 0.03222
Q1 0.1211
Median 0.2333
Q3 0.5005
95-th Percentile 0.665
Maximum 400
Range 400
IQR 0.3794

Descriptive Statistics

Standard Deviation 11.8453
Coefficient of Variation 18.1919
Kurtosis 1133.2285
Mean 0.6511
Median Absolute Deviation 0.2166
Skewness 33.6874
Sum 741.6361
Variance 140.311

country

categorical

Distinct Count 112
Unique (%) 2.9%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 13.762
Standard Deviation 8.4728
Median 9
Minimum 4
Maximum 34

Sample

1st Row united states of america
25% Row united states of america
50% Row canada
75% Row india
Last Row united states of america

Letter

Count 48914
Lowercase Letter 48914
Space Separator 4882
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 0

geography

categorical

Distinct Count 8
Unique (%) 0.2%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 1.9982
Standard Deviation 0.04227
Median 2
Minimum 1
Maximum 2

Sample

1st Row am
25% Row am
50% Row am
75% Row as
Last Row am

Letter

Count 7810
Lowercase Letter 7810
Space Separator 0
Uppercase Letter 0
Dash Punctuation 0
Decimal Number 7

region

categorical

Distinct Count 18
Unique (%) 0.5%
Missing 0
Missing (%) 0.0%
Memory Size 30.7 KB

Length

Mean 8.672
Standard Deviation 7.7904
Median 5
Minimum 1
Maximum 26

Sample

1st Row us
25% Row us
50% Row canada
75% Row india-south asia
Last Row us

Letter

Count 31053
Lowercase Letter 31053
Space Separator 2192
Uppercase Letter 0
Dash Punctuation 293
Decimal Number 7

Interactions

Correlations

Missing Values